﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data;

/// <summary>
/// Summary description for Country
/// </summary>
public class Country
{
    private int _country_id;

    public int CountryId
    {
        get { return _country_id; }
        set { _country_id = value; }
    }
    private string _country_name;

    public string CountryName
    {
        get { return _country_name; }
        set { _country_name = value; }
    }
    private string _status;

    public string Status
    {
        get { return _status; }
        set { _status = value; }
    }
    public Country()
	{
		
	}

    public DataSet SelectAllCountry(string countryname)
    {
        string sql = "select country_id,country_name,status from country where country_name Like '%" + Utility.cleanseText(countryname.Trim()) + "%'";
        DataSet results = DBHelper.GetDataFromDBInDataSet(sql);
        return results;
    }
}